{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Core Stationing","random numbers","Core Wksht","Blank Core Wksht","Core Stationing Blank","Notes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Core Stationing","index":0,"n_rows":214,"n_cols":38,"rows_kept":214,"cut":false,"hidden":false,"merged":[[53,2,53,3],[53,9,54,10],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[47,6,50,11],[35,1,36,1],[25,1,26,1],[27,1,28,1],[29,1,30,1],[31,1,32,1],[37,1,38,1],[39,1,40,1],[43,1,44,1],[46,2,46,3],[47,2,47,3],[48,2,48,3],[41,1,42,1],[4,12,4,13],[4,9,4,10],[5,7,5,8],[33,1,34,1],[4,7,4,8],[14,8,14,9],[5,9,5,11],[19,11,19,12],[17,11,17,12],[16,11,16,12],[7,8,7,10],[17,7,17,8],[18,7,18,8],[10,8,10,9],[0,5,0,11],[1,5,1,11],[8,8,8,10],[5,4,5,6],[18,11,18,12],[4,4,4,6],[11,8,11,9],[12,8,12,9],[13,8,13,9]]}
[null,null,null,null,null,"Bituminous Core Stationing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asphalt"]
[null,null,null,null,null,{"$f":"IF(L8=\"Yes\",\"with Longitudinal Joint Density\",\"\")","v":"with Longitudinal Joint Density"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop Down Box Lists",null,null,"County ",null,null,null,null,"Show","Type","Mix","Binder",null,null,null,"Density"]
[null,null,null,"2012-08-13",null,null,null,null,null,null,null,"Specification Year: 2012",null,null,null,null,null,null,null,null,null,null,"Project","Road Type","LJD?","Number","County","Tons","Lots","Direction","Companion Cores?","of","Type","Grade","Lift","Direction","Lane","Determination"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP","TH","Yes",null,null,0.1,0,{"$f":"IF(E10<F10,1,IF(E10=F10,0,IF(E10>F10,-1,\"NOT\")))","v":1},"All","Joint",null,null,"1st"]
[null,null,null,"SP",null,null,null,"TH",null,null,null,"Engineer",null,null,null,null,null,null,null,null,null,null,"SAP","CSAH","No",1,"Aitkin",1,1,0,"1 per Lot",null,"SPWEA230","B= PG 58-28","2nd","NB","Mainline","No"]
[null,null,null,"Contractor",null,null,null,"Plant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CP","CR",null,2,"Anoka",601,2,0,"No","Confined","SPWEA240","C= PG 58-34","3rd","SB","Left","Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Becker",1001,3,0,null,"Unconfined","SPWEA330","E= PG 64-28","4th","EB","Right"]
[null,"Lift","Direction","Lane","Begin Station","End Station","Lane Width",null,"Longitudinal Joint Density Project?",null,null,"Yes","Date Paved",null,null,null,null,null,null,null,null,null,null,null,null,4,"Beltrami",1601,4,0,null,null,"SPWEA340","F= PG 64-34","5th","WB","Left Center"]
[null,null,null,null,"(ft)","(ft)","(ft)",null,"1% Density Reduction?",null,null,"No","Day #",null,null,null,null,null,null,null,null,null,null,null,null,5,"Benton",2601,5,0,null,null,"SPWEA430","L= PG 64-22","6th",null,"Right Center"]
[null,"1st","NB","Driving",0,30000,12,null,null,null,null,null,"Date Cored",null,null,null,null,null,null,null,null,null,null,null,null,6,"Big Stone",4601,6,0,null,null,"SPWEA440","A= PG 52-34","7th",null,"Center"]
[null,null,null,null,null,null,null,null,"Total Density Tons Paved",null,500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Blue Earth",5501,7,0,null,null,"SPWEA530","H= PG 70-28",null,null,"Left Shldr"]
[null,null,null,null,null,null,null,null,"Tons Per Lot",null,{"$f":"K11/K14","v":500},null,"MDR/Rec#",null,null,null,null,null,null,null,null,null,null,null,null,8,"Brown",6401,8,0,null,null,"SPWEA540",null,null,null,"Right Shldr"]
[null,null,null,null,null,null,null,null,"Lots Used for Calcuations",null,{"$f":"IF(((ISNUMBER(K15))=TRUE),(K15),(VLOOKUP(K11,AB5:AC14,2)))","v":1},null,"Bid Price/Ton",null,null,null,null,null,null,null,null,null,null,null,null,9,"Carlton",7301,9,0,null,null,"SPWEB230",null,null,null,"Rt. Turn Lane"]
[null,null,null,null,null,null,null,null,"Lots Required",null,{"$f":"VLOOKUP(K11,AB4:AC14,2)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Carver",8201,10,null,null,null,"SPWEB240",null,null,null,"Lt. Turn Lane"]
[null,null,null,null,null,null,null,null,"Over-ride # Lots",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Cass",null,null,null,null,null,"SPWEB330",null,null,null,"Ramp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Chippewa",null,null,null,null,null,"SPWEB340",null,null,null,"Loop"]
[null,null,null,null,null,null,null,null,null,null,null,"Mix Spec",null,2360,null,null,null,null,null,null,null,null,null,null,null,13,"Chisago",null,null,null,null,null,"SPWEB430"]
[null,null,null,null,null,null,null,"Test Companion",null,null,null,"Mix Type",null,"SPWEB340",null,null,null,null,null,null,null,null,null,null,null,14,"Clay",null,null,null,null,null,"SPWEB440"]
[null,null,null,null,null,null,null,"Cores Shown?",null,"1 per Lot",null,"Asphalt Binder Grade",null,"C= PG 58-34",null,null,null,null,null,null,null,null,null,null,null,15,"Clearwater",null,null,null,null,null,"SPWEB530"]
[null,null,null,null,null,null,null,null,null,null,null,"Total Area Paved (yd2)",null,{"$f":"$J$95/9","v":40000},null,null,null,null,null,null,null,null,null,null,null,16,"Cook",null,null,null,null,null,"SPWEB540"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Cottonwood",null,null,null,null,null,"SPWEC230"]
[null,null,null,null,null,null,null,null,null,"Left",{"$f":"IF($L$8=\"Yes\",\"Left\",\"\")","v":"Left"},{"$f":"IF($L$8=\"Yes\",\"Left\",\"\")","v":"Left"},"Right",{"$f":"IF($L$8=\"Yes\",\"Right\",\"\")","v":"Right"},{"$f":"IF($L$8=\"Yes\",\"Right\",\"\")","v":"Right"},null,null,null,null,null,null,null,null,null,null,18,"Crow Wing",null,null,null,null,null,"SPWEC240"]
[null,null,"Mat",null,"Mat","Mat ","Mat","Mat","Test","LJD",{"$f":"IF($L$8=\"Yes\",\"LJD\",\"\")","v":"LJD"},{"$f":"IF($L$8=\"Yes\",\"LJD\",\"\")","v":"LJD"},"LJD",{"$f":"IF($L$8=\"Yes\",\"LJD\",\"\")","v":"LJD"},{"$f":"IF($L$8=\"Yes\",\"LJD\",\"\")","v":"LJD"},null,null,null,null,null,null,null,null,null,null,19,"Dakota",null,null,null,null,null,"SPWEC330"]
[null,null,"Core","Name","Core","Station","Offset","Offset","Companion","Joint",{"$f":"IF($L$8=\"Yes\",\"Core\",\"\")","v":"Core"},{"$f":"IF($L$8=\"Yes\",\"Offset\",\"\")","v":"Offset"},"Joint",{"$f":"IF($L$8=\"Yes\",\"Core\",\"\")","v":"Core"},{"$f":"IF($L$8=\"Yes\",\"Offset\",\"\")","v":"Offset"},null,null,null,null,null,null,null,null,null,null,20,"Dodge",null,null,null,null,null,"SPWEC340"]
[null,"Lot","ID",null,"Station","Random #","(ft.)","Random #","Core","Type",{"$f":"IF($L$8=\"Yes\",\"ID\",\"\")","v":"ID"},{"$f":"IF($L$8=\"Yes\",\"(ft.)\",\"\")","v":"(ft.)"},"Type",{"$f":"IF($L$8=\"Yes\",\"ID\",\"\")","v":"ID"},{"$f":"IF($L$8=\"Yes\",\"(ft.)\",\"\")","v":"(ft.)"},null,null,null,null,null,null,null,null,null,null,21,"Douglas",null,null,null,null,null,"SPWEC430"]
[null,1,{"$f":"IF(B26=\"\",\"\",B26+0.1)","v":1.1000000000000001},{"$f":"IF($K$13>=1,$E$110,\"\")","v":"Driving, 1st Lift, NB"},{"$f":"IF($K$13>=1,$E$109,\"\")","v":17330.998778343201},{"$f":"IF(C26=\"\",\"\",$E$100)","v":0.57769995927810669},{"$f":"$P$186","v":3.1604290008544922},{"$f":"IF(C26=\"\",\"\",G186)","v":0.26336908340454102},{"$f":"IF(ISNUMBER($B26),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F123=\"Y\"),$F123,\"\"))),\"\")","v":""},null,{"$f":"S186","v":""},{"$f":"T186","v":""},null,{"$f":"U186","v":""},{"$f":"V186","v":""},null,null,null,null,null,null,null,null,null,null,22,"Faribault",null,null,null,null,null,"SPWEC440"]
[null,null,{"$f":"IF(B26=\"\",\"\",B26+0.2)","v":1.2},{"$f":"IF($K$13>=1,$F$110,\"\")","v":"Driving, 1st Lift, NB"},{"$f":"IF($K$13>=1,$F$109,\"\")","v":5950.162410736084},{"$f":"IF(C27=\"\",\"\",$F$100)","v":0.19833874702453613},{"$f":"$P$187","v":4},0.23428791761398315,{"$f":"IF(ISNUMBER($B26),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F124=\"Y\"),$F124,\"\"))),\"\")","v":"Y"},null,1.3,"Core 0.5 ft. from Left Edge",null,1.4,"Core 0.5 ft. from Right Edge",null,null,null,null,null,null,null,null,null,null,23,"Fillmore",null,null,null,null,null,"SPWEC530"]
[null,{"$f":"IF($K$13>=2,B26+1,\"\")","v":""},{"$f":"IF(B28=\"\",\"\",B28+0.1)","v":""},{"$f":"IF($K$13>=2,$G$110,\"\")","v":""},{"$f":"IF($K$13>=2,$G$109,\"\")","v":""},{"$f":"IF(C28=\"\",\"\",$G$100)","v":""},{"$f":"$P$188","v":""},"",{"$f":"IF(ISNUMBER($B28),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F125=\"Y\"),$F125,\"\"))),\"\")","v":""},null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,24,"Freeborn",null,null,null,null,null,"SPWEC540"]
[null,null,{"$f":"IF(B28=\"\",\"\",B28+0.2)","v":""},{"$f":"IF($K$13>=2,$H$110,\"\")","v":""},{"$f":"IF($K$13>=2,$H$109,\"\")","v":""},{"$f":"IF(C29=\"\",\"\",$H$100)","v":""},{"$f":"$P$189","v":""},"",{"$f":"IF(ISNUMBER($B28),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F126=\"Y\"),$F126,\"\"))),\"\")","v":""},null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,25,"Goodhue",null,null,null,null,null,"SPNWA230"]
[null,{"$f":"IF($K$13>=3,B28+1,\"\")","v":""},{"$f":"IF(B30=\"\",\"\",B30+0.1)","v":""},{"$f":"IF($K$13>=3,$I$110,\"\")","v":""},{"$f":"IF($K$13>=3,$I$109,\"\")","v":""},{"$f":"IF(C30=\"\",\"\",$I$100)","v":""},{"$f":"$P$190","v":""},"",{"$f":"IF(ISNUMBER($B30),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F127=\"Y\"),$F127,\"\"))),\"\")","v":""},null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,26,"Grant",null,null,null,null,null,"SPNWA240"]
[null,null,{"$f":"IF(B30=\"\",\"\",B30+0.2)","v":""},{"$f":"IF($K$13>=3,$J$110,\"\")","v":""},{"$f":"IF($K$13>=3,$J$109,\"\")","v":""},{"$f":"IF(C31=\"\",\"\",$J$100)","v":""},{"$f":"$P$191","v":""},"",{"$f":"IF(ISNUMBER($B30),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F128=\"Y\"),$F128,\"\"))),\"\")","v":""},null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,27,"Hennepin",null,null,null,null,null,"SPNWA330"]
[null,{"$f":"IF($K$13>=4,B30+1,\"\")","v":""},{"$f":"IF(B32=\"\",\"\",B32+0.1)","v":""},{"$f":"IF($K$13>=4,$K$110,\"\")","v":""},{"$f":"IF($K$13>=4,$K$109,\"\")","v":""},{"$f":"IF(C32=\"\",\"\",$K$100)","v":""},{"$f":"$P$192","v":""},"",{"$f":"IF(ISNUMBER($B32),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F129=\"Y\"),$F129,\"\"))),\"\")","v":""},null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,28,"Houston",null,null,null,null,null,"SPNWA340"]
[null,null,{"$f":"IF(B32=\"\",\"\",B32+0.2)","v":""},{"$f":"IF($K$13>=4,$L$110,\"\")","v":""},{"$f":"IF($K$13>=4,$L$109,\"\")","v":""},{"$f":"IF(C33=\"\",\"\",$L$100)","v":""},{"$f":"$P$193","v":""},"",{"$f":"IF(ISNUMBER($B32),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F130=\"Y\"),$F130,\"\"))),\"\")","v":""},null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,29,"Hubbard",null,null,null,null,null,"SPNWA430"]
[null,{"$f":"IF($K$13>=5,B32+1,\"\")","v":""},{"$f":"IF(B34=\"\",\"\",B34+0.1)","v":""},{"$f":"IF($K$13>=5,$M$110,\"\")","v":""},{"$f":"IF($K$13>=5,$M$109,\"\")","v":""},{"$f":"IF(C34=\"\",\"\",$M$100)","v":""},{"$f":"$P$194","v":""},"",{"$f":"IF(ISNUMBER($B34),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F131=\"Y\"),$F131,\"\"))),\"\")","v":""},null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,30,"Isanti",null,null,null,null,null,"SPNWA440"]
[null,null,{"$f":"IF(B34=\"\",\"\",B34+0.2)","v":""},{"$f":"IF($K$13>=5,$N$110,\"\")","v":""},{"$f":"IF($K$13>=5,$N$109,\"\")","v":""},{"$f":"IF(C35=\"\",\"\",$N$100)","v":""},{"$f":"$P$195","v":""},"",{"$f":"IF(ISNUMBER($B34),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F132=\"Y\"),$F132,\"\"))),\"\")","v":""},null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,31,"Itasca",null,null,null,null,null,"SPNWA530"]
[null,{"$f":"IF($K$13>=6,B34+1,\"\")","v":""},{"$f":"IF(B36=\"\",\"\",B36+0.1)","v":""},{"$f":"IF($K$13>=6,$O$110,\"\")","v":""},{"$f":"IF($K$13>=6,$O$109,\"\")","v":""},{"$f":"IF(C36=\"\",\"\",$O$100)","v":""},{"$f":"$P$196","v":""},"",{"$f":"IF(ISNUMBER($B36),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F133=\"Y\"),$F133,\"\"))),\"\")","v":""},null,{"$f":"S196","v":""},{"$f":"T196","v":""},null,{"$f":"U196","v":""},{"$f":"V196","v":""},null,null,null,null,null,null,null,null,null,null,32,"Jackson",null,null,null,null,null,"SPNWA540"]
[null,null,{"$f":"IF(B36=\"\",\"\",B36+0.2)","v":""},{"$f":"IF($K$13>=6,$P$110,\"\")","v":""},{"$f":"IF($K$13>=6,$P$109,\"\")","v":""},{"$f":"IF(C37=\"\",\"\",$P$100)","v":""},{"$f":"$P$197","v":""},"",{"$f":"IF(ISNUMBER($B36),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F134=\"Y\"),$F134,\"\"))),\"\")","v":""},null,{"$f":"S197","v":""},{"$f":"T197","v":""},null,{"$f":"U197","v":""},{"$f":"V197","v":""},null,null,null,null,null,null,null,null,null,null,33,"Kanabec",null,null,null,null,null,"SPNWB230"]
[null,{"$f":"IF($K$13>=7,B36+1,\"\")","v":""},{"$f":"IF(B38=\"\",\"\",B38+0.1)","v":""},{"$f":"IF($K$13>=7,$O$110,\"\")","v":""},{"$f":"IF($K$13>=7,$Q$109,\"\")","v":""},{"$f":"IF(C38=\"\",\"\",$Q$100)","v":""},{"$f":"$P$198","v":""},"",{"$f":"IF(ISNUMBER($B38),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F135=\"Y\"),$F135,\"\"))),\"\")","v":""},null,{"$f":"S198","v":""},{"$f":"T198","v":""},null,{"$f":"U198","v":""},"",null,null,null,null,null,null,null,null,null,null,34,"Kanndiyohi",null,null,null,null,null,"SPNWB240"]
[null,null,{"$f":"IF(B38=\"\",\"\",B38+0.2)","v":""},{"$f":"IF($K$13>=7,$P$110,\"\")","v":""},{"$f":"IF($K$13>=7,$R$109,\"\")","v":""},{"$f":"IF(C39=\"\",\"\",$R$100)","v":""},{"$f":"$P$199","v":""},"",{"$f":"IF(ISNUMBER($B38),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F136=\"Y\"),$F136,\"\"))),\"\")","v":""},null,"","",null,{"$f":"U199","v":""},"",null,null,null,null,null,null,null,null,null,null,35,"Kittson",null,null,null,null,null,"SPNWB330"]
[null,{"$f":"IF($K$13>=8,B38+1,\"\")","v":""},{"$f":"IF(B40=\"\",\"\",B40+0.1)","v":""},{"$f":"IF($K$13>=8,$O$110,\"\")","v":""},{"$f":"IF($K$13>=8,$S$109,\"\")","v":""},{"$f":"IF(C40=\"\",\"\",$S$100)","v":""},{"$f":"$P$200","v":""},"",{"$f":"IF(ISNUMBER($B40),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F137=\"Y\"),$F137,\"\"))),\"\")","v":""},null,"","",null,{"$f":"U200","v":""},"",null,null,null,null,null,null,null,null,null,null,36,"Koochiching",null,null,null,null,null,"SPNWB340"]
[null,null,{"$f":"IF(B40=\"\",\"\",B40+0.2)","v":""},{"$f":"IF($K$13>=8,$P$110,\"\")","v":""},{"$f":"IF($K$13>=8,$T$109,\"\")","v":""},{"$f":"IF(C41=\"\",\"\",$T$100)","v":""},{"$f":"$P$201","v":""},"",{"$f":"IF(ISNUMBER($B40),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F138=\"Y\"),$F138,\"\"))),\"\")","v":""},null,"","",null,{"$f":"U201","v":""},"",null,null,null,null,null,null,null,null,null,null,37,"Lac qui Parle",null,null,null,null,null,"SPNWB430"]
[null,{"$f":"IF($K$13>=9,B40+1,\"\")","v":""},{"$f":"IF(B42=\"\",\"\",B42+0.1)","v":""},{"$f":"IF($K$13>=9,$O$110,\"\")","v":""},{"$f":"IF($K$13>=9,$U$109,\"\")","v":""},{"$f":"IF(C42=\"\",\"\",$U$100)","v":""},{"$f":"$P$202","v":""},"",{"$f":"IF(ISNUMBER($B42),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F139=\"Y\"),$F139,\"\"))),\"\")","v":""},null,"","",null,{"$f":"U202","v":""},"",null,null,null,null,null,null,null,null,null,null,38,"Lake",null,null,null,null,null,"SPNWB440"]
[null,null,{"$f":"IF(B42=\"\",\"\",B42+0.2)","v":""},{"$f":"IF($K$13>=9,$P$110,\"\")","v":""},{"$f":"IF($K$13>=9,$V$109,\"\")","v":""},{"$f":"IF(C43=\"\",\"\",$V$100)","v":""},{"$f":"$P$203","v":""},"",{"$f":"IF(ISNUMBER($B42),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F140=\"Y\"),$F140,\"\"))),\"\")","v":""},null,"","",null,{"$f":"U203","v":""},"",null,null,null,null,null,null,null,null,null,null,39,"Lake of the Woods",null,null,null,null,null,"SPNWB530"]
[null,{"$f":"IF($K$13>=10,B42+1,\"\")","v":""},{"$f":"IF(B44=\"\",\"\",B44+0.1)","v":""},{"$f":"IF($K$13>=10,$O$110,\"\")","v":""},{"$f":"IF($K$13>=10,$W$109,\"\")","v":""},{"$f":"IF(C44=\"\",\"\",$W$100)","v":""},{"$f":"$P$204","v":""},"",{"$f":"IF(ISNUMBER($B44),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F141=\"Y\"),$F141,\"\"))),\"\")","v":""},null,"","",null,{"$f":"U204","v":""},"",null,null,null,null,null,null,null,null,null,null,40,"Le Sueur",null,null,null,null,null,"SPNWB540"]
[null,null,{"$f":"IF(B44=\"\",\"\",B44+0.2)","v":""},{"$f":"IF($K$13>=10,$P$110,\"\")","v":""},{"$f":"IF($K$13>=10,$X$109,\"\")","v":""},{"$f":"IF(C45=\"\",\"\",$X$100)","v":""},{"$f":"$P$205","v":""},"",{"$f":"IF(ISNUMBER($B44),(IF($J$19=\"All\",\"Y\",IF(AND($J$19=\"1 per Lot\",$F142=\"Y\"),$F142,\"\"))),\"\")","v":""},null,"","",null,{"$f":"U205","v":""},"",null,null,null,null,null,null,null,null,null,null,41,"Lincoln",null,null,null,null,null,"SPNWC230"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,"Lyon",null,null,null,null,null,"SPNWC240"]
[null,null,"Daily Production",null,null,null,"Remarks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,"Mahnomen",null,null,null,null,null,"SPNWC330"]
[null,null,"English Tons",null,"Lot",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,"Marshall",null,null,null,null,null,"SPNWC340"]
[null,null,"0-600",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,"Martin",null,null,null,null,null,"SPNWC430"]
[null,null,"601-1000",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,"McLeod",null,null,null,null,null,"SPNWC440"]
[null,null,"1001-1600",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,"Meeker",null,null,null,null,null,"SPNWC530"]
[null,null,"1601-2600",null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,"Mille Lacs",null,null,null,null,null,"SPNWC540"]
[null,null,"2601-4600",null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,"Morrison"]
[null,null,">4601*",null,6,null,"Street Inspector",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"Mower"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,"Murray"]
[null,null,"* Add one additional lot each additional 900 tons",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"Nicollet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,"Nobles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,"Norman"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,"Olmsted"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,"Otter Tail"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,"Pennington"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,"Pine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,"Pipestone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"Polk"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,"Pope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,"Ramsey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,"Red Lake"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,"Redwood"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,"Renville"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,"Rice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,"Rock"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,"Roseau"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,"Scott"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,"Sherburne"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,"Sibley"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,"St. Louis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,"Stearns"]
[null,null,"Given information from User:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,"Steele"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sum",null,null,null,null,null,null,null,null,null,null,null,null,75,"Stevens"]
[null,null,null,null,null,null,null,"Lane","Lane",null,"Area",null,"Lane",null,null,null,null,null,null,null,null,null,null,null,null,76,"Swift"]
[null,null,null,null,null,null,null,"Length","Area","Station","to test","Direction","Area",null,null,null,null,null,null,null,null,null,null,null,null,77,"Todd"]
[null,null,null,"Lane Name","Lane Letter for Calcs.","Begin Station","End Station","Lane Width","(ft)","(ft2)","Random #","(ft2)",null,"(ft2)","Lane Name","Lane Name",null,null,null,null,null,null,null,null,null,78,"Traverse"]
[null,null,null,{"$f":"CONCATENATE($D10,\", \",$B10,\" Lift\",\", \",$C10)","v":"Driving, 1st Lift, NB"},"A",{"$f":"E10","v":0},30000,12,{"$f":"ABS(G83-F83)","v":30000},{"$f":"I83*H83","v":360000},{"$f":"'random numbers'!B200","v":0.19407343864440918},{"$f":"J83*K83","v":69866.437911987305},{"$f":"IF(E10<F10,1,IF(E10=F10,0,IF(E10>F10,-1,\"NOT\")))","v":1},0,{"$f":"E83","v":"A"},{"$f":"CONCATENATE($D10,\", \",$B10,\" Lift\",\", \",$C10)","v":"Driving, 1st Lift, NB"},null,null,null,null,null,null,null,null,null,79,"Wabasha"]
[null,null,null,{"$f":"CONCATENATE($D11,\", \",$B11,\" Lift\",\", \",$C11)","v":",  Lift, "},"B",0,0,0,0,0,{"$f":"'random numbers'!B201","v":0.22171586751937866},{"$f":"J84*K84","v":0},0,{"$f":"J83","v":360000},{"$f":"E84","v":"B"},",  Lift, ",null,null,null,null,null,null,null,null,null,80,"Wadena"]
[null,null,null,",  Lift, ","C",0,0,0,0,0,{"$f":"'random numbers'!B202","v":0.61553418636322021},0,0,{"$f":"SUM($J$83:J84)","v":360000},"C",",  Lift, ",null,null,null,null,null,null,null,null,null,81,"Waseca"]
[null,null,null,",  Lift, ","D",0,0,0,0,0,{"$f":"'random numbers'!B203","v":0.19134241342544556},0,0,{"$f":"SUM($J$83:J85)","v":360000},"D",",  Lift, ",null,null,null,null,null,null,null,null,null,82,"Washington"]
[null,null,null,",  Lift, ","E",0,0,0,0,0,{"$f":"'random numbers'!B204","v":0.62962818145751953},0,0,{"$f":"SUM($J$83:J86)","v":360000},"E",",  Lift, ",null,null,null,null,null,null,null,null,null,83,"Watonwan"]
[null,null,null,",  Lift, ","F",0,0,0,0,0,{"$f":"'random numbers'!B205","v":0.50513952970504761},0,0,{"$f":"SUM($J$83:J87)","v":360000},"F",",  Lift, ",null,null,null,null,null,null,null,null,null,84,"Wilkin"]
[null,null,null,",  Lift, ","G",0,0,0,0,0,{"$f":"'random numbers'!B206","v":0.24499952793121338},0,0,{"$f":"SUM($J$83:J88)","v":360000},"G",",  Lift, ",null,null,null,null,null,null,null,null,null,85,"Winona"]
[null,null,null,",  Lift, ","H",0,0,0,0,0,{"$f":"'random numbers'!B207","v":0.11373740434646606},0,0,{"$f":"SUM($J$83:J89)","v":360000},"H",",  Lift, ",null,null,null,null,null,null,null,null,null,86,"Wright"]
[null,null,null,",  Lift, ","I",0,0,0,0,0,{"$f":"'random numbers'!B208","v":0.68007016181945801},0,0,{"$f":"SUM($J$83:J90)","v":360000},"I",",  Lift, ",null,null,null,null,null,null,null,null,null,87,"Yellow Medicine"]
[null,null,null,",  Lift, ","J",0,0,0,0,0,{"$f":"'random numbers'!B209","v":0.15093272924423218},0,0,{"$f":"SUM($J$83:J91)","v":360000},"J",",  Lift, "]
[]
[null,null,null,null,null,null,null,null,null,"Total Area","# of Lots","Area/Lot"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J83:J92)","v":360000},{"$f":"IF(K13=\"\",\"\",K13)","v":1},{"$f":"J95/K95","v":360000}]
[]
[null,null,"Determination of Mat Core Stationing:"]
[null,null,null,"Lot #",{"$f":"$B$26","v":1},{"$f":"$B$26","v":1},{"$f":"$B$26+1","v":2},{"$f":"$B$26+1","v":2},{"$f":"$B$26+2","v":3},{"$f":"$B$26+2","v":3},{"$f":"$B$26+3","v":4},{"$f":"$B$26+3","v":4},{"$f":"$B$26+4","v":5},{"$f":"$B$26+4","v":5},{"$f":"$B$26+5","v":6},{"$f":"$B$26+5","v":6},{"$f":"$B$26+6","v":7},{"$f":"$B$26+6","v":7},{"$f":"$B$26+7","v":8},{"$f":"$B$26+7","v":8},{"$f":"$B$26+8","v":9},{"$f":"$B$26+8","v":9},{"$f":"$B$26+9","v":10},{"$f":"$B$26+9","v":10}]
[null,null,null,null,"1st Core","2nd Core","1st Core","2nd Core","1st Core","2nd Core","1st Core","2nd Core","1st Core","2nd Core","1st Core","2nd Core","2nd Core","2nd Core","2nd Core","2nd Core","2nd Core","2nd Core","2nd Core","2nd Core"]
[null,null,null,"Lot Random # A",{"$f":"'random numbers'!$B$15","v":0.57769995927810669},{"$f":"'random numbers'!$B$16","v":0.19833874702453613},{"$f":"'random numbers'!$B$17","v":0.8656582236289978},{"$f":"'random numbers'!$B$18","v":0.21349227428436279},{"$f":"'random numbers'!$B$19","v":0.30811268091201782},{"$f":"'random numbers'!$B$20","v":4.7383785247802734E-2},{"$f":"'random numbers'!$B$21","v":0.447673499584198},{"$f":"'random numbers'!$B$22","v":0.32999527454376221},{"$f":"'random numbers'!$B$23","v":0.62095719575881958},{"$f":"'random numbers'!$B$24","v":0.37178969383239746},{"$f":"'random numbers'!$B$25","v":0.93563741445541382},{"$f":"'random numbers'!$B$26","v":0.73255860805511475},{"$f":"'random numbers'!$B$27","v":6.3901960849761963E-2},{"$f":"'random numbers'!$B$28","v":0.34105110168457031},{"$f":"'random numbers'!$B$29","v":0.38356608152389526},{"$f":"'random numbers'!$B$30","v":0.57163393497467041},{"$f":"'random numbers'!$B$31","v":0.24809199571609497},{"$f":"'random numbers'!$B$32","v":0.93423295021057129},{"$f":"'random numbers'!$B$33","v":0.41676467657089233},{"$f":"'random numbers'!$B$34","v":0.2838057279586792}]
[null,null,null,"Random Area",{"$f":"$L95*E100","v":207971.98534011841},{"$f":"$L95*F100","v":71401.948928833008},{"$f":"$L95+($L95*G100)","v":671636.96050643921},{"$f":"$L95+($L95*H100)","v":436857.21874237061},{"$f":"($L95*2)+($L95*I100)","v":830920.56512832642},{"$f":"($L95*2)+($L95*J100)","v":737058.16268920898},{"$f":"($L95*3)+($L95*K100)","v":1241162.4598503113},{"$f":"($L95*3)+($L95*L100)","v":1198798.2988357544},{"$f":"($L95*4)+($L95*M100)","v":1663544.590473175},{"$f":"($L95*4)+($L95*N100)","v":1573844.2897796631},{"$f":"($L95*5)+($L95*O100)","v":2136829.469203949},{"$f":"($L95*5)+($L95*P100)","v":2063721.0988998413},{"$f":"($L95*6)+($L95*Q100)","v":2183004.7059059143},{"$f":"($L95*6)+($L95*R100)","v":2282778.3966064453},{"$f":"($L95*7)+($L95*S100)","v":2658083.7893486023},{"$f":"($L95*7)+($L95*T100)","v":2725788.2165908813},{"$f":"($L95*8)+($L95*U100)","v":2969313.1184577942},{"$f":"($L95*8)+($L95*V100)","v":3216323.8620758057},{"$f":"($L95*9)+($L95*W100)","v":3390035.2835655212},{"$f":"($L95*9)+($L95*X100)","v":3342170.0620651245}]
[null,null,null,"Lane Letter to take core",{"$f":"VLOOKUP(E101,$N$83:$O$92,2)","v":"A"},"A","J","J","J","J","J","J","J","J","J","J",{"$f":"VLOOKUP(Q101,$N$83:$O$92,2)","v":"J"},"J","J","J","J","J","J","J"]
[null,null,null,"Total Lane Area",{"$f":"VLOOKUP(E102,$E83:$J92,6,FALSE)","v":360000},360000,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(Q102,$E83:$J92,6,FALSE)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Sum Lane Area",{"$f":"(VLOOKUP(E102,$E83:$N92,10,FALSE))+E103","v":360000},360000,360000,360000,360000,360000,360000,360000,360000,360000,360000,360000,{"$f":"(VLOOKUP(Q102,$E83:$N92,10,FALSE))+Q103","v":360000},360000,360000,360000,360000,360000,360000,360000]
[null,null,null,"Lane Width",{"$f":"VLOOKUP(E102,$E83:$H92,4,FALSE)","v":12},12,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(Q102,$E83:$H92,4,FALSE)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Lane End Station",{"$f":"VLOOKUP(E102,$E83:$G92,3,FALSE)","v":30000},30000,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(Q102,$E83:$G92,3,FALSE)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Direction",{"$f":"VLOOKUP(E102,$E$83:$M$92,9,FALSE)","v":1},1,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(Q102,$E$83:$M$92,9,FALSE)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Distance from end of Station to core",{"$f":"(E104-E101)/E105","v":12669.001221656799},{"$f":"(F104-F101)/F105","v":24049.837589263916},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"(Q104-Q101)/Q105","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"Lane Station to Core",{"$f":"E106-(E107*(E108))","v":17330.998778343201},5950.162410736084,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Q106-(Q107*(Q108))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"X106-(X107*(X108))","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Lane Name",{"$f":"VLOOKUP(E102,$O83:$P92,2)","v":"Driving, 1st Lift, NB"},{"$f":"VLOOKUP(F102,$O83:$P92,2)","v":"Driving, 1st Lift, NB"},",  Lift, ",",  Lift, ",",  Lift, ",",  Lift, ",",  Lift, ",",  Lift, ",",  Lift, ",",  Lift, ",",  Lift, ",",  Lift, ",{"$f":"VLOOKUP(Q102,$O83:$P92,2)","v":",  Lift, "},",  Lift, ",",  Lift, ",",  Lift, ",",  Lift, ",",  Lift, ",",  Lift, ",",  Lift, "]
[]
[]
[]
[]
[]
[]
[null,null,"Determination of which core the agency will test:"]
[]
[null,null,null,null,"Test","Which"]
[null,null,null,{"$f":"C23","v":"Mat"},"Companion","Core to"]
[null,null,null,"Core","Random #","Test"]
[null,null,{"$f":"B25","v":"Lot"},"ID"]
[null,null,{"$f":"B26","v":1},1.1000000000000001,{"$f":"'random numbers'!$B$150","v":0.89189255237579346},{"$f":"IF(E123<0.5,\"Y\",\"N\")","v":"N"}]
[null,null,null,1.2,null,{"$f":"IF(E123>0.5,\"Y\",\"N\")","v":"Y"}]
[null,null,{"$f":"B28","v":""},"",{"$f":"'random numbers'!$B$151","v":0.94307786226272583},{"$f":"IF(E125<0.5,\"Y\",\"N\")","v":"N"}]
[null,null,null,"",null,{"$f":"IF(E125>0.5,\"Y\",\"N\")","v":"Y"}]
[null,null,{"$f":"B30","v":""},"",{"$f":"'random numbers'!$B$152","v":0.38199019432067871},{"$f":"IF(E127<0.5,\"Y\",\"N\")","v":"Y"}]
[null,null,null,"",null,{"$f":"IF(E127>0.5,\"Y\",\"N\")","v":"N"}]
[null,null,{"$f":"B32","v":""},"",{"$f":"'random numbers'!$B$153","v":0.97534841299057007},{"$f":"IF(E129<0.5,\"Y\",\"N\")","v":"N"}]
[null,null,null,"",null,{"$f":"IF(E129>0.5,\"Y\",\"N\")","v":"Y"}]
[null,null,{"$f":"B34","v":""},"",{"$f":"'random numbers'!$B$154","v":0.402488112449646},{"$f":"IF(E131<0.5,\"Y\",\"N\")","v":"Y"}]
[null,null,null,"",null,{"$f":"IF(E131>0.5,\"Y\",\"N\")","v":"N"}]
[null,null,{"$f":"B36","v":""},"",{"$f":"'random numbers'!$B$155","v":0.68692594766616821},{"$f":"IF(E133<0.5,\"Y\",\"N\")","v":"N"}]
[null,null,null,"",null,{"$f":"IF(E133>0.5,\"Y\",\"N\")","v":"Y"}]
[null,null,{"$f":"B38","v":""},{"$f":"C38","v":""},{"$f":"'random numbers'!$B$156","v":0.57354164123535156},{"$f":"IF(E135<0.5,\"Y\",\"N\")","v":"N"}]
[null,null,null,{"$f":"C39","v":""},null,{"$f":"IF(E135>0.5,\"Y\",\"N\")","v":"Y"}]
[null,null,{"$f":"B40","v":""},"",{"$f":"'random numbers'!$B$157","v":0.38140696287155151},{"$f":"IF(E137<0.5,\"Y\",\"N\")","v":"Y"}]
[null,null,null,"",null,{"$f":"IF(E137>0.5,\"Y\",\"N\")","v":"N"}]
[null,null,{"$f":"B42","v":""},"",{"$f":"'random numbers'!$B$158","v":0.49217379093170166},{"$f":"IF(E139<0.5,\"Y\",\"N\")","v":"Y"}]
[null,null,null,"",null,{"$f":"IF(E139>0.5,\"Y\",\"N\")","v":"N"}]
[null,null,{"$f":"B44","v":""},"",{"$f":"'random numbers'!$B$159","v":0.74428492784500122},{"$f":"IF(E141<0.5,\"Y\",\"N\")","v":"N"}]
[null,null,null,"",null,{"$f":"IF(E141>0.5,\"Y\",\"N\")","v":"Y"}]
[]
[]
[]
[]
[null,null,"Determine LJD cores to Test:",null,null,null,null,null,null,null,null,null,"Determine 2nd LJD Core"]
[null,null,"1st LJD Core"]
[null,null,null,"1ST","1ST",null,null,null,null,null,null,null,"2nd","2nd","overlap of values"]
[null,null,null,"LJD","LJD","Is Mat","(For","Sub","Decision Tree for",null,"Associated",null,"LJD","LJD","and determine","Sub","Decision Tree for",null,"Associated"]
[null,null,"Number of","Lot","Which","Core","Calculations)","Core","Mat Core ID",{"$f":"C183","v":"Mat"},"Mat",null,"Lot","Which","which 2nd","Core","Mat Core ID",{"$f":"J151","v":"Mat"},"Mat"]
[null,null,"LJD","Random","Core","a Value (\"v\")","Core","Random","that will be",{"$f":"C184","v":"Core"},"Core with",null,"Random","Core","LJD core to ","Random","that will be","Core","Core with"]
[null,null,"Lots","Number","to Test","or Blank (\"l\")","#","Numbers","tested",{"$f":"C185","v":"ID"},"LJD Cores",null,"Number","to Test","use","Numbers","tested","ID","LJD Cores"]
[null,null,null,null,null,null,null,null,"(1=Yes, 2=No)",null,null,null,null,null,null,null,"(1=Yes, 2=No)"]
[null,null,{"$f":"IF($K$11<=5000,1,2)","v":1},{"$f":"'random numbers'!$B$90","v":0.28773820400238037},{"$f":"ROUND((($K$13)*D155),0)","v":0},{"$f":"CELL(\"type\",C186)","v":"v"},{"$f":"IF(F155=\"v\",1,\"\")","v":1},{"$f":"'random numbers'!$B$160","v":0.67221665382385254},{"$f":"IF(AND(($E$160=$G155),(H155<0.5)),1,2)","v":2},{"$f":"C186","v":1.1000000000000001},{"$f":"VLOOKUP(1,I155:J174,2,FALSE)","v":1.2},null,{"$f":"'random numbers'!$B$115","v":0.96477276086807251},{"$f":"IF($C$155>1,ROUND((($K$13)*M155),0),\"\")","v":""},{"$f":"IF(N155=\"\",\"\",IF(N165<>$E$160,N165,IF(N166<>$E$160,N166,N167)))","v":""},{"$f":"'random numbers'!$B$166","v":0.45691120624542236},{"$f":"IF(AND(($O$155=$G155),(P155<0.5)),1,2)","v":2},1.1000000000000001,{"$f":"VLOOKUP(1,Q155:R174,2,FALSE)","v":""}]
[null,null,null,{"$f":"'random numbers'!$B$91","v":0.21476942300796509},{"$f":"ROUND((($K$13)*D156),0)","v":0},"v",null,null,{"$f":"IF(AND(($E$160=$G$155),($H155>=0.5)),1,2)","v":1},1.2,null,null,null,null,null,null,{"$f":"IF(AND(($O$155=$G$155),(P155>=0.5)),1,2)","v":2},1.2]
[null,null,null,{"$f":"'random numbers'!$B$92","v":0.43922996520996094},{"$f":"ROUND((($K$13)*D157),0)","v":0},"l",{"$f":"IF(F157=\"v\",2,\"\")","v":""},{"$f":"'random numbers'!$B$161","v":0.52312606573104858},{"$f":"IF(AND(($E$160=$G157),(H157<0.5)),1,2)","v":2},"",null,null,{"$f":"'random numbers'!$B$116","v":0.59107542037963867},{"$f":"IF($C$155>1,ROUND((($K$13)*M157),0),\"\")","v":""},null,{"$f":"'random numbers'!$B$167","v":0.90524846315383911},{"$f":"IF(AND(($O$155=$G157),(P157<0.5)),1,2)","v":2},""]
[null,null,null,{"$f":"'random numbers'!$B$93","v":0.43668574094772339},{"$f":"ROUND((($K$13)*D158),0)","v":0},"l",null,null,{"$f":"IF(AND(($E$160=$G$157),($H157>=0.5)),1,2)","v":2},"",null,null,null,null,null,null,{"$f":"IF(AND(($O$155=$G$157),(P157>=0.5)),1,2)","v":1},""]
[null,null,null,null,null,"l",{"$f":"IF(F159=\"v\",3,\"\")","v":""},{"$f":"'random numbers'!$B$162","v":3.7840604782104492E-3},{"$f":"IF(AND(($E$160=$G159),(H159<0.5)),1,2)","v":2},"",null,null,{"$f":"'random numbers'!$B$117","v":0.27558296918869019},{"$f":"IF($C$155>1,ROUND((($K$13)*M159),0),\"\")","v":""},null,{"$f":"'random numbers'!$B$168","v":0.52379870414733887},{"$f":"IF(AND(($O$155=$G159),(P159<0.5)),1,2)","v":2},""]
[null,null,null,null,{"$f":"IF(AND((E155>0),(E155<=$K$13)),E155,IF(AND((E156>0),(E156<=$K$13)),E156,IF(AND((E157>0),(E157<=$K$13)),E157,IF(AND((E158>0),(E158<=$K$13)),E158,1))))","v":1},"l",null,null,{"$f":"IF(AND(($E$160=$G$159),($H159>=0.5)),1,2)","v":2},"",null,null,null,null,null,null,{"$f":"IF(AND(($O$155=$G$159),(P159>=0.5)),1,2)","v":1},""]
[null,null,null,null,null,"l",{"$f":"IF(F161=\"v\",4,\"\")","v":""},{"$f":"'random numbers'!$B$163","v":0.64915138483047485},{"$f":"IF(AND(($E$160=$G161),(H161<0.5)),1,2)","v":2},"",null,null,{"$f":"'random numbers'!$B$118","v":0.46931374073028564},{"$f":"IF($C$155>1,ROUND((($K$13)*M161),0),\"\")","v":""},null,{"$f":"'random numbers'!$B$169","v":0.4649619460105896},{"$f":"IF(AND(($O$155=$G161),(P161<0.5)),1,2)","v":1},""]
[null,null,null,null,null,"l",null,null,{"$f":"IF(AND(($E$160=$G$161),($H161>=0.5)),1,2)","v":2},"",null,null,null,null,null,null,{"$f":"IF(AND(($O$155=$G$161),(P161>=0.5)),1,2)","v":2},""]
[null,null,null,null,null,"l",{"$f":"IF(F163=\"v\",5,\"\")","v":""},{"$f":"'random numbers'!$B$164","v":0.88852548599243164},{"$f":"IF(AND(($E$160=$G163),(H163<0.5)),1,2)","v":2},"",null,null,{"$f":"'random numbers'!$B$119","v":0.33386117219924927},{"$f":"IF($C$155>1,ROUND((($K$13)*M163),0),\"\")","v":""},null,{"$f":"'random numbers'!$B$170","v":0.1885303258895874},{"$f":"IF(AND(($O$155=$G163),(P163<0.5)),1,2)","v":1},""]
[null,null,null,null,null,"l",null,null,{"$f":"IF(AND(($E$160=$G$163),($H163>=0.5)),1,2)","v":2},"",null,null,null,null,null,null,{"$f":"IF(AND(($O$155=$G$163),(P163>=0.5)),1,2)","v":2},""]
[null,null,null,null,null,{"$f":"CELL(\"type\",C196)","v":"l"},{"$f":"IF(F165=\"v\",6,\"\")","v":""},{"$f":"'random numbers'!$B$165","v":0.33147495985031128},{"$f":"IF(AND(($E$160=$G165),(H165<0.5)),1,2)","v":2},{"$f":"C196","v":""},null,null,"1st Choice",{"$f":"IF(AND(($N$155>0),($N$155<=$K$13)),$N$155,IF(AND(($N$157>0),($N$157<=$K$13)),$N$157,IF(AND(($N$159>0),($N$159<=$K$13)),$N$159,1)))","v":1},null,{"$f":"'random numbers'!$B$171","v":0.56415086984634399},{"$f":"IF(AND(($O$155=$G165),(P165<0.5)),1,2)","v":2},""]
[null,null,null,null,null,"l",null,null,{"$f":"IF(AND(($E$160=$G$165),($H165>=0.5)),1,2)","v":2},"",null,null,"2nd Choice",{"$f":"IF(AND(($N$157>0),($N$157<=$K$13)),$N$157,IF(AND(($N$159>0),($N$159<=$K$13)),$N$159,1))","v":1},null,null,{"$f":"IF(AND(($O$155=$G$165),(P165>=0.5)),1,2)","v":1},""]
[null,null,null,null,null,"l",{"$f":"IF(F167=\"v\",7,\"\")","v":""},{"$f":"'random numbers'!$B$166","v":0.45691120624542236},{"$f":"IF(AND(($E$160=$G167),(H167<0.5)),1,2)","v":2},"",null,null,"3rd Choice",{"$f":"IF(AND(($N$159>0),($N$159<=$K$13)),$N$159,1)","v":1},null,{"$f":"'random numbers'!$B$172","v":0.23581218719482422},{"$f":"IF(AND(($O$155=$G167),(P167<0.5)),1,2)","v":1},{"$f":"J167","v":""}]
[null,null,null,null,null,"l",null,null,{"$f":"IF(AND(($E$160=$G$167),($H167>=0.5)),1,2)","v":2},"",null,null,null,null,null,null,{"$f":"IF(AND(($O$155=$G$167),(P167>=0.5)),1,2)","v":2},""]
[null,null,null,null,null,"l",{"$f":"IF(F169=\"v\",8,\"\")","v":""},{"$f":"'random numbers'!$B$167","v":0.90524846315383911},{"$f":"IF(AND(($E$160=$G169),(H169<0.5)),1,2)","v":2},"",null,null,null,null,null,{"$f":"'random numbers'!$B$173","v":0.51275938749313354},{"$f":"IF(AND(($O$155=$G169),(P169<0.5)),1,2)","v":2},""]
[null,null,null,null,null,"l",null,null,{"$f":"IF(AND(($E$160=$G$169),($H169>=0.5)),1,2)","v":2},"",null,null,null,null,null,null,{"$f":"IF(AND(($O$155=$G$169),(P169>=0.5)),1,2)","v":1},""]
[null,null,null,null,null,"l",{"$f":"IF(F171=\"v\",9,\"\")","v":""},{"$f":"'random numbers'!$B$168","v":0.52379870414733887},{"$f":"IF(AND(($E$160=$G171),(H171<0.5)),1,2)","v":2},"",null,null,null,null,null,{"$f":"'random numbers'!$B$174","v":0.74362432956695557},{"$f":"IF(AND(($O$155=$G171),(P171<0.5)),1,2)","v":2},""]
[null,null,null,null,null,"l",null,null,{"$f":"IF(AND(($E$160=$G$171),($H171>=0.5)),1,2)","v":2},"",null,null,null,null,null,null,{"$f":"IF(AND(($O$155=$G$171),(P171>=0.5)),1,2)","v":1},""]
[null,null,null,null,null,"l",{"$f":"IF(F173=\"v\",10,\"\")","v":""},{"$f":"'random numbers'!$B$169","v":0.4649619460105896},{"$f":"IF(AND(($E$160=$G173),(H173<0.5)),1,2)","v":2},"",null,null,null,null,null,{"$f":"'random numbers'!$B$175","v":5.3409874439239502E-2},{"$f":"IF(AND(($O$155=$G173),(P173<0.5)),1,2)","v":1},""]
[null,null,null,null,null,"l",null,null,{"$f":"IF(AND(($E$160=$G$173),($H173>=0.5)),1,2)","v":2},"",null,null,null,null,null,null,{"$f":"IF(AND(($O$155=$G$173),(P173>=0.5)),1,2)","v":2},""]
[]
[]
[]
[null,null,"Mat Core Offset Determination:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LJD Cores","LJD Core Labels:"]
[null,null,null,null,null,null,null,null,"Before ","Confined","Unconfined","Non LJD",null,null,null,null,null,"Tested?"]
[null,null,null,null,null,null,null,null,"Checking for","Mat","Mat","Mat","Decision Tree for","Gearbox","Right or"]
[null,null,null,null,null,null,null,null,"LJD changes","Offset","Offset","Core","Mat Offset","Offset","Left of","Mat Offset",null,{"$f":"IF(AND(($L$8=\"Yes\"),($L$9=\"No\")),\"Yes\",\"No\")","v":"Yes"},"Left LJD","Left LJD Core","Right LJD","Right LJD Core"]
[null,null,null,null,null,null,"Mat","Lane","Mat",null,null,"Offset","that will be","Random","Gearbox","that will",null,null,"Core ID","Offset Label for Table","Core ID","Offset Label for Table"]
[null,null,{"$f":"C23","v":"Mat"},{"$f":"I23","v":"Test"},{"$f":"E23","v":"Mat"},{"$f":"D23","v":0},"Offset","Width","Offset",null,null,null,"tested for LJD","Numbers","that will be ","be tested",null,null,"Label",null,"Label"]
[null,null,"Core","Companion","Core",{"$f":"D24","v":"Name"},"Random#","(ft.)","(ft.)","(ft.)","(ft.)","(ft.)","(1=Yes, 2=No)",null,"tested","(ft.)"]
[null,null,"ID","Core","Station",null,null,null,null,null,null,null,null,null,"(Left = -2ft, Right= +2ft)"]
[null,null,1.1000000000000001,"",17330.998778343201,{"$f":"E102","v":"A"},{"$f":"'random numbers'!$B100","v":0.26336908340454102},{"$f":"VLOOKUP(F186,$E$83:$H$92,4,FALSE)","v":12},{"$f":"IF(C186=\"\",\"\",IF(((H186*G186)<1),1,IF(((H186*G186)>(H186-1)),H186-1,H186*G186)))","v":3.1604290008544922},{"$f":"IF(C186=\"\",\"\",IF(M26=\"confined\",IF((G186*H186)<0.5,0.5,IF(((G186*H186)>(H186-0.5)),(H186-0.5),(G186*H186))),\"unconf/blank\"))","v":"unconf/blank"},{"$f":"IF(C186=\"\",\"\",IF(OR((M26=\"unconfined\"),(M26=\"\")),IF((G186*H186)<1,1,IF((G186*H186)>(H186-1),(H186-1),(G186*H186))),\"confined\"))","v":3.1604290008544922},{"$f":"IF(J186=\"unconf/blank\",K186,J186)","v":3.1604290008544922},{"$f":"IF(OR(($K$155=C186),($S$155=C186)),1,2)","v":2},{"$f":"'random numbers'!B180","v":0.6471400260925293},{"$f":"IF(N186<0.5,-2,2)","v":2},{"$f":"IF(C186=\"\",\"\",IF($R$181=\"No\",L186,IF(M186=1,(((H186)/2)+O186),I186)))","v":3.1604290008544922},null,null,{"$f":"IF(C186=\"\",\"\",IF($R$181=\"No\",\"\",IF(M186=1,C186+0.2,\"\")))","v":""},{"$f":"IF(C186=\"\",\"\",IF($R$181=\"No\",\"\",IF(M186=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C186=\"\",\"\",IF($R$181=\"No\",\"\",IF(M186=1,C186+0.3,\"\")))","v":""},{"$f":"IF(C186=\"\",\"\",IF($R$181=\"No\",\"\",IF(M186=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,1.2,"Y",5950.162410736084,{"$f":"F102","v":"A"},{"$f":"'random numbers'!$B101","v":0.23428791761398315},12,2.8114550113677979,"unconf/blank",2.8114550113677979,{"$f":"IF(J187=\"unconf/blank\",K187,J187)","v":2.8114550113677979},1,{"$f":"'random numbers'!B181","v":0.33004540205001831},-2,{"$f":"IF(C187=\"\",\"\",IF($R$181=\"No\",L187,IF(M187=1,(((H187)/2)+O187),I187)))","v":4},null,null,{"$f":"IF(C186=\"\",\"\",IF($R$181=\"No\",\"\",IF(M187=1,C187+0.1,\"\")))","v":1.3},{"$f":"IF(C186=\"\",\"\",IF($R$181=\"No\",\"\",IF(M187=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":"Core 0.5 ft. from Left Edge"},{"$f":"IF(C186=\"\",\"\",IF($R$181=\"No\",\"\",IF(M187=1,C187+0.2,\"\")))","v":1.4},{"$f":"IF(C186=\"\",\"\",IF($R$181=\"No\",\"\",IF(M187=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":"Core 0.5 ft. from Right Edge"}]
[null,null,"","","",{"$f":"G102","v":"J"},{"$f":"'random numbers'!$B102","v":0.66644108295440674},0,"","","","",1,{"$f":"'random numbers'!B182","v":0.63795769214630127},2,"",null,null,{"$f":"IF(C188=\"\",\"\",IF($R$181=\"No\",\"\",IF(M188=1,C188+0.2,\"\")))","v":""},{"$f":"IF(C188=\"\",\"\",IF($R$181=\"No\",\"\",IF(M188=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C188=\"\",\"\",IF($R$181=\"No\",\"\",IF(M188=1,C188+0.3,\"\")))","v":""},{"$f":"IF(C188=\"\",\"\",IF($R$181=\"No\",\"\",IF(M188=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,"","","",{"$f":"H102","v":"J"},{"$f":"'random numbers'!$B103","v":0.52275258302688599},0,"","","","",1,{"$f":"'random numbers'!B183","v":0.83183556795120239},2,"",null,null,{"$f":"IF(C188=\"\",\"\",IF($R$181=\"No\",\"\",IF(M189=1,C189+0.1,\"\")))","v":""},{"$f":"IF(C188=\"\",\"\",IF($R$181=\"No\",\"\",IF(M189=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C188=\"\",\"\",IF($R$181=\"No\",\"\",IF(M189=1,C189+0.2,\"\")))","v":""},{"$f":"IF(C188=\"\",\"\",IF($R$181=\"No\",\"\",IF(M189=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,"","","",{"$f":"I102","v":"J"},{"$f":"'random numbers'!$B104","v":0.93300509452819824},0,"","","","",1,{"$f":"'random numbers'!B184","v":0.33485770225524902},-2,"",null,null,{"$f":"IF(C190=\"\",\"\",IF($R$181=\"No\",\"\",IF(M190=1,C190+0.2,\"\")))","v":""},{"$f":"IF(C190=\"\",\"\",IF($R$181=\"No\",\"\",IF(M190=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C190=\"\",\"\",IF($R$181=\"No\",\"\",IF(M190=1,C190+0.3,\"\")))","v":""},{"$f":"IF(C190=\"\",\"\",IF($R$181=\"No\",\"\",IF(M190=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,"","","",{"$f":"J102","v":"J"},{"$f":"'random numbers'!$B105","v":0.45218652486801147},0,"","","","",1,{"$f":"'random numbers'!B185","v":0.25932401418685913},-2,"",null,null,{"$f":"IF(C190=\"\",\"\",IF($R$181=\"No\",\"\",IF(M191=1,C191+0.1,\"\")))","v":""},{"$f":"IF(C190=\"\",\"\",IF($R$181=\"No\",\"\",IF(M191=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C190=\"\",\"\",IF($R$181=\"No\",\"\",IF(M191=1,C191+0.2,\"\")))","v":""},{"$f":"IF(C190=\"\",\"\",IF($R$181=\"No\",\"\",IF(M191=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,"","","",{"$f":"K102","v":"J"},{"$f":"'random numbers'!$B106","v":0.58232533931732178},0,"","","","",1,{"$f":"'random numbers'!B186","v":0.12282693386077881},-2,"",null,null,{"$f":"IF(C192=\"\",\"\",IF($R$181=\"No\",\"\",IF(M192=1,C192+0.2,\"\")))","v":""},{"$f":"IF(C192=\"\",\"\",IF($R$181=\"No\",\"\",IF(M192=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C192=\"\",\"\",IF($R$181=\"No\",\"\",IF(M192=1,C192+0.3,\"\")))","v":""},{"$f":"IF(C192=\"\",\"\",IF($R$181=\"No\",\"\",IF(M192=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,"","","",{"$f":"L102","v":"J"},{"$f":"'random numbers'!$B107","v":0.31635957956314087},0,"","","","",1,{"$f":"'random numbers'!B187","v":0.80911260843276978},2,"",null,null,{"$f":"IF(C192=\"\",\"\",IF($R$181=\"No\",\"\",IF(M193=1,C193+0.1,\"\")))","v":""},{"$f":"IF(C192=\"\",\"\",IF($R$181=\"No\",\"\",IF(M193=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C192=\"\",\"\",IF($R$181=\"No\",\"\",IF(M193=1,C193+0.2,\"\")))","v":""},{"$f":"IF(C192=\"\",\"\",IF($R$181=\"No\",\"\",IF(M193=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,"","","",{"$f":"M102","v":"J"},{"$f":"'random numbers'!$B108","v":0.17840480804443359},0,"","","","",1,{"$f":"'random numbers'!B188","v":0.35737228393554688},-2,"",null,null,{"$f":"IF(C194=\"\",\"\",IF($R$181=\"No\",\"\",IF(M194=1,C194+0.2,\"\")))","v":""},{"$f":"IF(C194=\"\",\"\",IF($R$181=\"No\",\"\",IF(M194=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C194=\"\",\"\",IF($R$181=\"No\",\"\",IF(M194=1,C194+0.3,\"\")))","v":""},{"$f":"IF(C194=\"\",\"\",IF($R$181=\"No\",\"\",IF(M194=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,"","","",{"$f":"N102","v":"J"},{"$f":"'random numbers'!$B109","v":8.732527494430542E-2},0,"","","","",1,{"$f":"'random numbers'!B189","v":0.57874315977096558},2,"",null,null,{"$f":"IF(C194=\"\",\"\",IF($R$181=\"No\",\"\",IF(M195=1,C195+0.1,\"\")))","v":""},{"$f":"IF(C194=\"\",\"\",IF($R$181=\"No\",\"\",IF(M195=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C194=\"\",\"\",IF($R$181=\"No\",\"\",IF(M195=1,C195+0.2,\"\")))","v":""},{"$f":"IF(C194=\"\",\"\",IF($R$181=\"No\",\"\",IF(M195=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,{"$f":"C36","v":""},{"$f":"I36","v":""},{"$f":"E36","v":""},{"$f":"O102","v":"J"},{"$f":"'random numbers'!$B110","v":0.81289541721343994},0,"","","","",1,{"$f":"'random numbers'!B190","v":0.25368082523345947},-2,"",null,null,{"$f":"IF(C196=\"\",\"\",IF($R$181=\"No\",\"\",IF(M196=1,C196+0.2,\"\")))","v":""},{"$f":"IF(C196=\"\",\"\",IF($R$181=\"No\",\"\",IF(M196=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C196=\"\",\"\",IF($R$181=\"No\",\"\",IF(M196=1,C196+0.3,\"\")))","v":""},{"$f":"IF(C196=\"\",\"\",IF($R$181=\"No\",\"\",IF(M196=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,{"$f":"C37","v":""},{"$f":"I37","v":""},{"$f":"E37","v":""},{"$f":"P102","v":"J"},{"$f":"'random numbers'!$B111","v":0.46669036149978638},0,"","","","",1,{"$f":"'random numbers'!B191","v":0.39921694993972778},-2,"",null,null,{"$f":"IF(C196=\"\",\"\",IF($R$181=\"No\",\"\",IF(M197=1,C197+0.1,\"\")))","v":""},{"$f":"IF(C196=\"\",\"\",IF($R$181=\"No\",\"\",IF(M197=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C196=\"\",\"\",IF($R$181=\"No\",\"\",IF(M197=1,C197+0.2,\"\")))","v":""},{"$f":"IF(C196=\"\",\"\",IF($R$181=\"No\",\"\",IF(M197=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,{"$f":"C38","v":""},{"$f":"I38","v":""},{"$f":"E38","v":""},{"$f":"Q102","v":"J"},{"$f":"'random numbers'!$B112","v":0.45128941535949707},{"$f":"VLOOKUP(F198,$E$83:$H$92,4,FALSE)","v":0},{"$f":"IF(C198=\"\",\"\",IF(((H198*G198)<1),1,IF(((H198*G198)>(H198-1)),H198-1,H198*G198)))","v":""},"","",{"$f":"IF(J198=\"unconf/blank\",K198,J198)","v":""},{"$f":"IF(OR(($K$155=C198),($S$155=C198)),1,2)","v":1},{"$f":"'random numbers'!B192","v":0.88906121253967285},{"$f":"IF(N198<0.5,-2,2)","v":2},{"$f":"IF(C198=\"\",\"\",IF($R$181=\"No\",L198,IF(M198=1,(((H198)/2)+O198),I198)))","v":""},null,null,{"$f":"IF(C198=\"\",\"\",IF($R$181=\"No\",\"\",IF(M198=1,C198+0.1,\"\")))","v":""},{"$f":"IF(C198=\"\",\"\",IF($R$181=\"No\",\"\",IF(M198=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C198=\"\",\"\",IF($R$181=\"No\",\"\",IF(M198=1,C198+0.2,\"\")))","v":""},{"$f":"IF(C198=\"\",\"\",IF($R$181=\"No\",\"\",IF(M198=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,"","","",{"$f":"R102","v":"J"},{"$f":"'random numbers'!$B113","v":0.34704059362411499},0,"","","","",1,{"$f":"'random numbers'!B193","v":0.32767051458358765},-2,"",null,null,{"$f":"IF(C198=\"\",\"\",IF($R$181=\"No\",\"\",IF(M199=1,C199+0.1,\"\")))","v":""},{"$f":"IF(C198=\"\",\"\",IF($R$181=\"No\",\"\",IF(M199=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C198=\"\",\"\",IF($R$181=\"No\",\"\",IF(M199=1,C199+0.2,\"\")))","v":""},{"$f":"IF(C198=\"\",\"\",IF($R$181=\"No\",\"\",IF(M199=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,"","","",{"$f":"S102","v":"J"},{"$f":"'random numbers'!$B114","v":4.864203929901123E-2},0,"","","","",1,{"$f":"'random numbers'!B194","v":0.22491633892059326},-2,"",null,null,{"$f":"IF(C200=\"\",\"\",IF($R$181=\"No\",\"\",IF(M200=1,C200+0.1,\"\")))","v":""},{"$f":"IF(C200=\"\",\"\",IF($R$181=\"No\",\"\",IF(M200=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C200=\"\",\"\",IF($R$181=\"No\",\"\",IF(M200=1,C200+0.2,\"\")))","v":""},{"$f":"IF(C200=\"\",\"\",IF($R$181=\"No\",\"\",IF(M200=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,"","","",{"$f":"T102","v":"J"},{"$f":"'random numbers'!$B115","v":0.96477276086807251},0,"","","","",1,{"$f":"'random numbers'!B195","v":8.1457674503326416E-2},-2,"",null,null,"","","",""]
[null,null,"","","",{"$f":"U102","v":"J"},{"$f":"'random numbers'!$B116","v":0.59107542037963867},0,"","","","",1,{"$f":"'random numbers'!B196","v":0.30449724197387695},-2,"",null,null,{"$f":"IF(C202=\"\",\"\",IF($R$181=\"No\",\"\",IF(M202=1,C202+0.1,\"\")))","v":""},{"$f":"IF(C202=\"\",\"\",IF($R$181=\"No\",\"\",IF(M202=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},{"$f":"IF(C202=\"\",\"\",IF($R$181=\"No\",\"\",IF(M202=1,C202+0.2,\"\")))","v":""},{"$f":"IF(C202=\"\",\"\",IF($R$181=\"No\",\"\",IF(M202=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,"","","",{"$f":"V102","v":"J"},{"$f":"'random numbers'!$B117","v":0.27558296918869019},0,"","","","",1,{"$f":"'random numbers'!B197","v":0.94488781690597534},2,"",null,null,"","","",""]
[null,null,"","","",{"$f":"W102","v":"J"},{"$f":"'random numbers'!$B118","v":0.46931374073028564},0,"","","","",1,{"$f":"'random numbers'!B198","v":3.2688260078430176E-2},-2,"",null,null,{"$f":"IF(C204=\"\",\"\",IF($R$181=\"No\",\"\",IF(M204=1,C204+0.1,\"\")))","v":""},{"$f":"IF(C204=\"\",\"\",IF($R$181=\"No\",\"\",IF(M204=1,\"Core 0.5 ft. from Left Edge\",\"\")))","v":""},"",{"$f":"IF(C204=\"\",\"\",IF($R$181=\"No\",\"\",IF(M204=1,\"Core 0.5 ft. from Right Edge\",\"\")))","v":""}]
[null,null,"","","",{"$f":"X102","v":"J"},{"$f":"'random numbers'!$B119","v":0.33386117219924927},0,"","","","",1,{"$f":"'random numbers'!B199","v":0.92987042665481567},2,"",null,null,"","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Reset Random Numbers= CTRL m"]

{"sheet":"random numbers","index":1,"n_rows":220,"n_cols":2,"rows_kept":220,"cut":false,"hidden":true,"merged":[]}
[0.9121362566947937,0.13687843084335327]
[0.8455883264541626,0.73869884014129639]
[0.62532550096511841,0.71589142084121704]
[0.55169320106506348,0.87385225296020508]
[0.69396156072616577,0.81885403394699097]
[0.79831492900848389,0.6646958589553833]
[0.33092743158340454,0.2721288800239563]
[0.52982759475708008,0.4524543285369873]
[0.52660244703292847,0.59110444784164429]
[0.8018571138381958,7.377469539642334E-2]
[0.8217657208442688,0.11740213632583618]
[0.5587775707244873,0.94910526275634766]
[0.61332124471664429,0.25373953580856323]
[0.11886441707611084,0.8781057596206665]
[0.89164835214614868,0.57769995927810669]
[0.16677188873291016,0.19833874702453613]
[7.5822055339813232E-2,0.8656582236289978]
[0.942146897315979,0.21349227428436279]
[0.74969702959060669,0.30811268091201782]
[9.4090700149536133E-2,4.7383785247802734E-2]
[0.5920681357383728,0.447673499584198]
[0.89487349987030029,0.32999527454376221]
[0.92414051294326782,0.62095719575881958]
[0.33780431747436523,0.37178969383239746]
[0.690288245677948,0.93563741445541382]
[0.89841568470001221,0.73255860805511475]
[0.61824113130569458,6.3901960849761963E-2]
[0.36675429344177246,0.34105110168457031]
[0.83932393789291382,0.38356608152389526]
[0.48393189907073975,0.57163393497467041]
[0.42840391397476196,0.24809199571609497]
[0.98060798645019531,0.93423295021057129]
[0.57326334714889526,0.41676467657089233]
[0.87392580509185791,0.2838057279586792]
[0.28645259141921997,0.9262738823890686]
[0.84560990333557129,0.70559549331665039]
[0.35508865118026733,0.93495243787765503]
[0.8266524076461792,0.48241627216339111]
[0.7264752984046936,0.32092076539993286]
[0.55816507339477539,0.80021929740905762]
[0.18772953748703003,6.538766622543335E-2]
[0.54830372333526611,9.8190665245056152E-2]
[0.21731358766555786,0.70235735177993774]
[0.85269427299499512,0.21963024139404297]
[0.27444833517074585,0.36599272489547729]
[7.1503043174743652E-2,0.76986181735992432]
[0.75603777170181274,0.21688491106033325]
[0.19510936737060547,0.33742451667785645]
[0.73694914579391479,0.27847903966903687]
[0.70490515232086182,0.48479545116424561]
[0.87966567277908325,0.96490627527236938]
[0.12242817878723145,0.66489362716674805]
[0.98761600255966187,0.83147209882736206]
[0.39205253124237061,0.46961510181427002]
[0.50663906335830688,0.32905083894729614]
[0.75635480880737305,0.86664938926696777]
[0.82025688886642456,0.59363645315170288]
[0.66117393970489502,0.33082711696624756]
[0.99747735261917114,0.55229955911636353]
[5.0884008407592773E-2,2.6248931884765625E-2]
[0.96929258108139038,0.87680071592330933]
[0.98111093044281006,0.44544565677642822]
[0.27355200052261353,0.56610995531082153]
[0.39622879028320313,0.1618196964263916]
[0.36361712217330933,0.1890825629234314]
[1.5178322792053223E-2,0.60161769390106201]
[0.38839083909988403,6.8541109561920166E-2]
[0.3147585391998291,0.9916844367980957]
[0.8635515570640564,0.93801373243331909]
[0.96790492534637451,0.88924801349639893]
[0.56283432245254517,0.85237866640090942]
[0.2928929328918457,0.94998621940612793]
[0.69619244337081909,0.38366502523422241]
[0.97144711017608643,0.84062421321868896]
[0.25693494081497192,0.38325983285903931]
[0.99394679069519043,0.45231342315673828]
[0.84522813558578491,0.84177130460739136]
[0.55696332454681396,0.82104170322418213]
[0.79858881235122681,0.62779837846755981]
[0.33929157257080078,0.41132473945617676]
[0.51392096281051636,0.13685649633407593]
[0.92478621006011963,0.66942870616912842]
[0.65370780229568481,0.13170963525772095]
[0.99810147285461426,2.3741722106933594E-3]
[2.7237355709075928E-2,0.30535858869552612]
[0.53330504894256592,0.58897125720977783]
[0.82815128564834595,0.34793549776077271]
[0.24181509017944336,0.67913603782653809]
[0.85987824201583862,0.54875463247299194]
[0.80242645740509033,0.28773820400238037]
[0.77151948213577271,0.21476942300796509]
[0.27076506614685059,0.43922996520996094]
[0.27449315786361694,0.43668574094772339]
[0.12236344814300537,0.36930620670318604]
[0.31317335367202759,0.9839814305305481]
[0.61610984802246094,0.33984589576721191]
[0.94318598508834839,0.36008208990097046]
[0.75869524478912354,0.97338473796844482]
[0.4368012547492981,0.29894310235977173]
[0.48404145240783691,0.26336908340454102]
[0.66562408208847046,0.23428791761398315]
[0.44877231121063232,0.66644108295440674]
[0.87975364923477173,0.52275258302688599]
[0.46217584609985352,0.93300509452819824]
[0.49826496839523315,0.45218652486801147]
[0.45231449604034424,0.58232533931732178]
[0.37059193849563599,0.31635957956314087]
[0.47481417655944824,0.17840480804443359]
[0.64730066061019897,8.732527494430542E-2]
[0.97551381587982178,0.81289541721343994]
[null,0.46669036149978638]
[null,0.45128941535949707]
[null,0.34704059362411499]
[null,4.864203929901123E-2]
[null,0.96477276086807251]
[null,0.59107542037963867]
[null,0.27558296918869019]
[null,0.46931374073028564]
[null,0.33386117219924927]
[null,0.8404996395111084]
[null,0.70724195241928101]
[null,0.88454186916351318]
[null,0.20756155252456665]
[null,0.11124420166015625]
[null,0.46947115659713745]
[null,0.12446558475494385]
[null,0.15795642137527466]
[null,0.49956154823303223]
[null,0.83601325750350952]
[null,0.68035686016082764]
[null,0.77372986078262329]
[null,5.1899433135986328E-2]
[null,0.23002499341964722]
[null,0.59524548053741455]
[null,0.98829251527786255]
[null,0.78052592277526855]
[null,0.17720216512680054]
[null,0.60454404354095459]
[null,0.65790659189224243]
[null,0.92915439605712891]
[null,0.50890463590621948]
[null,0.52667295932769775]
[null,0.38981086015701294]
[null,0.48856854438781738]
[null,0.81528133153915405]
[null,0.90368545055389404]
[null,0.62034565210342407]
[null,0.96224737167358398]
[null,0.14839524030685425]
[null,0.89189255237579346]
[null,0.94307786226272583]
[null,0.38199019432067871]
[null,0.97534841299057007]
[null,0.402488112449646]
[null,0.68692594766616821]
[null,0.57354164123535156]
[null,0.38140696287155151]
[null,0.49217379093170166]
[null,0.74428492784500122]
[null,0.67221665382385254]
[null,0.52312606573104858]
[null,3.7840604782104492E-3]
[null,0.64915138483047485]
[null,0.88852548599243164]
[null,0.33147495985031128]
[null,0.45691120624542236]
[null,0.90524846315383911]
[null,0.52379870414733887]
[null,0.4649619460105896]
[null,0.1885303258895874]
[null,0.56415086984634399]
[null,0.23581218719482422]
[null,0.51275938749313354]
[null,0.74362432956695557]
[null,5.3409874439239502E-2]
[null,0.5544121265411377]
[null,0.44782871007919312]
[null,0.51580893993377686]
[null,0.25467830896377563]
[null,0.6471400260925293]
[null,0.33004540205001831]
[null,0.63795769214630127]
[null,0.83183556795120239]
[null,0.33485770225524902]
[null,0.25932401418685913]
[null,0.12282693386077881]
[null,0.80911260843276978]
[null,0.35737228393554688]
[null,0.57874315977096558]
[null,0.25368082523345947]
[null,0.39921694993972778]
[null,0.88906121253967285]
[null,0.32767051458358765]
[null,0.22491633892059326]
[null,8.1457674503326416E-2]
[null,0.30449724197387695]
[null,0.94488781690597534]
[null,3.2688260078430176E-2]
[null,0.92987042665481567]
[null,0.19407343864440918]
[null,0.22171586751937866]
[null,0.61553418636322021]
[null,0.19134241342544556]
[null,0.62962818145751953]
[null,0.50513952970504761]
[null,0.24499952793121338]
[null,0.11373740434646606]
[null,0.68007016181945801]
[null,0.15093272924423218]
[null,0.16626250743865967]
[null,2.4020731449127197E-2]
[null,0.17700338363647461]
[null,0.22678345441818237]
[null,0.48875916004180908]
[null,0.65638428926467896]
[null,0.73035216331481934]
[null,0.46541875600814819]
[null,0.32680833339691162]
[null,0.73037153482437134]
[null,0.99398612976074219]

{"sheet":"Core Wksht","index":2,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":true,"merged":[[0,0,0,1],[0,3,0,4],[0,6,0,9],[0,12,0,13],[2,0,2,1],[2,2,2,3],[2,6,2,7],[2,8,2,9],[1,0,1,1],[1,2,1,3],[1,6,1,7],[1,8,1,9],[1,11,1,12],[1,13,1,14],[2,11,2,12],[2,13,2,14],[3,11,3,12],[3,13,3,14],[4,11,4,12],[4,13,4,14],[3,0,3,1],[3,2,3,3],[4,0,4,1],[4,2,4,3],[4,6,4,7],[4,8,4,9],[3,6,3,7],[3,8,3,9],[26,6,26,8],[7,0,8,0],[11,6,11,8],[12,0,13,0],[16,6,16,8],[17,0,18,0],[21,6,21,8],[22,0,23,0],[37,0,37,4],[37,6,37,8],[37,11,37,13],[38,11,38,13],[27,0,28,0],[31,6,31,8],[32,0,33,0],[36,6,36,8]]}
["TIME  IN:",null,null,"TIME OUT:",null,null,"CORE       WORKSHEET             "]
[{"$f":"'Core Stationing'!$D$5","v":"SP"},null,{"$f":"'Core Stationing'!$E$5","v":0},null,null,null,"MDR/Rec.#",null,{"$f":"'Core Stationing'!$N$12","v":0},null,null,"LJD Mat Core"]
[{"$f":"'Core Stationing'!$H$5","v":"TH"},null,{"$f":"'Core Stationing'!$J$5","v":0},null,null,null," Mix Type",null,{"$f":"'Core Stationing'!$N$18","v":"SPWEB340"},null,null," Total  Tons"]
["Engineer",null,{"$f":"'Core Stationing'!$M$5","v":0},null,null,null,"Date Paved",null,{"$f":"'Core Stationing'!$N$8","v":"00:00:00"},null,null,"Density Tons"]
["Contractor",null,{"$f":"'Core Stationing'!$E$6","v":0},null,null,null,"Date Cored",null,{"$f":"'Core Stationing'!$N$10","v":"00:00:00"},null,null,"Misc. Tons"]
[null,null,"Thickness","AIR DRY","CORE/PAN",null,null,null,null,null,"%  WATER",null,"AVE. ","MAX.","FINAL DENSITY"]
["LOT","CORE #","(mm)/in","CORE","(or dry wt.)","PAN ID.","PAN WT.","DRY WT.","SSD WT.","IMM. WT.","ABSORBED","Sp GRAV.","Sp GRAV.","GRAVITY","% 0F MAXIMUM "]
[{"$f":"'Core Stationing'!$B$26","v":1},{"$f":"'Core Stationing'!$C$26","v":1.1000000000000001}]
[null,{"$f":"'Core Stationing'!$C$27","v":1.2}]
["COMP",{"$f":"B8","v":1.1000000000000001}]
["COMP",{"$f":"B9","v":1.2}]
[]
[{"$f":"'Core Stationing'!$B$28","v":""},{"$f":"'Core Stationing'!$C$28","v":""}]
[null,{"$f":"'Core Stationing'!$C$29","v":""}]
["COMP",{"$f":"B13","v":""}]
["COMP",{"$f":"B14","v":""}]
[]
[{"$f":"'Core Stationing'!$B$30","v":""},{"$f":"'Core Stationing'!$C$30","v":""}]
[null,{"$f":"'Core Stationing'!$C$31","v":""}]
["COMP",{"$f":"B18","v":""}]
["COMP",{"$f":"B19","v":""}]
[]
[{"$f":"'Core Stationing'!$B$32","v":""},{"$f":"'Core Stationing'!$C$32","v":""}]
[null,{"$f":"'Core Stationing'!$C$33","v":""}]
["COMP",{"$f":"B23","v":""}]
["COMP",{"$f":"B24","v":""}]
[]
[{"$f":"'Core Stationing'!$B$34","v":""},{"$f":"'Core Stationing'!$C$34","v":""}]
[null,{"$f":"'Core Stationing'!$C$35","v":""}]
["COMP",{"$f":"B28","v":""}]
["COMP",{"$f":"B29","v":""}]
[]
[{"$f":"'Core Stationing'!$B$36","v":""},{"$f":"'Core Stationing'!$C$36","v":""}]
[null,{"$f":"'Core Stationing'!$C$37","v":""}]
["COMP",{"$f":"B33","v":""}]
["COMP",{"$f":"B34","v":""}]
[]
[" COMPANION  CORE,  TESTED BY Mn/DOT,  CHECK .030 TOLERANCE.",null,null,null,null,"QC",null,null,null,null,"QA"]

{"sheet":"Blank Core Wksht","index":3,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":true,"merged":[[21,6,21,8],[37,0,37,4],[37,6,37,8],[37,11,37,13],[38,11,38,13],[22,0,23,0],[26,6,26,8],[27,0,28,0],[31,6,31,8],[32,0,33,0],[36,6,36,8],[7,0,8,0],[11,6,11,8],[12,0,13,0],[16,6,16,8],[17,0,18,0],[4,11,4,12],[4,13,4,14],[3,0,3,1],[3,2,3,3],[4,0,4,1],[4,2,4,3],[4,6,4,7],[4,8,4,9],[3,6,3,7],[3,8,3,9],[3,11,3,12],[3,13,3,14],[2,13,2,14],[0,0,0,1],[0,3,0,4],[0,6,0,9],[0,12,0,13],[1,0,1,1],[1,2,1,3],[1,6,1,7],[1,8,1,9],[1,11,1,12],[1,13,1,14],[2,0,2,1],[2,2,2,3],[2,6,2,7],[2,8,2,9],[2,11,2,12]]}
["TIME  IN:",null,null,"TIME OUT:",null,null,"CORE       WORKSHEET             "]
[{"$f":"'Core Stationing'!$D$5","v":"SP"},null,null,null,null,null,"MDR/Rec.#",null,null,null,null,"LJD Mat Core"]
[{"$f":"'Core Stationing'!$H$5","v":"TH"},null,null,null,null,null," Mix Type",null,null,null,null," Total  Tons"]
["Engineer",null,null,null,null,null,"Date Paved",null,null,null,null,"Density Tons"]
["Contractor",null,null,null,null,null,"Date Cored",null,null,null,null,"Misc. Tons"]
[null,null,"Thickness","AIR DRY","CORE/PAN",null,null,null,null,null,"%  WATER",null,"AVE. ","MAX.","FINAL DENSITY"]
["LOT","CORE #","(mm)/in","CORE","(or dry wt.)","PAN ID.","PAN WT.","DRY WT.","SSD WT.","IMM. WT.","ABSORBED","Sp GRAV.","Sp GRAV.","GRAVITY","% 0F MAXIMUM "]
[]
[]
["COMP"]
["COMP"]
[]
[]
[]
["COMP"]
["COMP"]
[]
[]
[]
["COMP"]
["COMP"]
[]
[]
[]
["COMP"]
["COMP"]
[]
[]
[]
["COMP"]
["COMP"]
[]
[]
[]
["COMP"]
["COMP"]
[]
[" COMPANION  CORE,  TESTED BY Mn/DOT,  CHECK .030 TOLERANCE.",null,null,null,null,"QC",null,null,null,null,"QA"]

{"sheet":"Core Stationing Blank","index":4,"n_rows":67,"n_cols":38,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,5,0,11],[1,5,1,11],[8,8,8,10],[4,12,4,13],[4,9,4,10],[5,7,5,8],[33,1,34,1],[4,7,4,8],[14,8,14,9],[5,9,5,11],[19,11,19,12],[17,11,17,12],[16,11,16,12],[11,8,11,9],[12,8,12,9],[13,8,13,9],[25,1,26,1],[27,1,28,1],[29,1,30,1],[31,1,32,1],[37,1,38,1],[50,6,50,11],[51,6,51,11],[35,1,36,1],[48,2,48,3],[49,2,49,3],[39,1,40,1],[41,1,42,1],[43,1,44,1],[54,2,54,3],[48,6,48,11],[49,6,49,11],[4,4,4,6],[5,4,5,6],[47,2,47,4],[7,8,7,10],[17,7,17,8],[18,7,18,8],[10,8,10,9],[18,11,18,12],[50,2,50,3],[51,2,51,3],[52,2,52,3],[53,2,53,3]]}
[null,null,null,null,null,"Bituminous Core Stationing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asphalt"]
[null,null,null,null,null,{"$f":"IF(L8=\"Yes\",\"with Longitudinal Joint Density\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop Down Box Lists",null,null,"County ",null,null,null,null,"Show","Type","Mix","Binder",null,null,null,"Density"]
[null,null,null,"2012-04-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project","Road Type","LJD?","Number","County","Tons","Lots","Direction","Companion Cores?","of","Type","Grade","Lift","Direction","Lane","Determination"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP","TH","Yes",null,null,0.1,0,{"$f":"IF(E10<F10,1,IF(E10=F10,0,IF(E10>F10,-1,\"NOT\")))","v":0},"All","Joint",null,null,"1st"]
[null,null,null,"SP/SAP/CR",null,null,null,"TH/CSAHCR",null,null,null,"Engineer",null,null,null,null,null,null,null,null,null,null,"SAP","CSAH","No",1,"Aitkin",1,1,0,"1 per Lot",null,"SPWEA230","B= PG 58-28","2nd","NB","Mainline","No"]
[null,null,null,"Contractor",null,null,null,"Plant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CP","CR",null,2,"Anoka",601,2,0,"No","Confined","SPWEA240","C= PG 58-34","3rd","SB","Left","Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Becker",1001,3,0,null,"Unconfined","SPWEA330","E= PG 64-28","4th","EB","Right"]
[null,"Lift","Direction","Lane","Begin Station","End Station","Lane Width",null,"Longitudinal Joint Density Project?",null,null,null,"Date Paved",null,null,null,null,null,null,null,null,null,null,null,null,4,"Beltrami",1601,4,0,null,null,"SPWEA340","F= PG 64-34","5th","WB","Left Center"]
[null,null,null,null,"(ft)","(ft)","(ft)",null,"1% Density Reduction?",null,null,null,"Day #",null,null,null,null,null,null,null,null,null,null,null,null,5,"Benton",3601,5,0,null,null,"SPWEA430","L= PG 64-22","6th",null,"Right Center"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Date Cored",null,null,null,null,null,null,null,null,null,null,null,null,6,"Big Stone",5001,6,0,null,null,"SPWEA440","A= PG 52-34","7th",null,"Center"]
[null,null,null,null,null,null,null,null,"Total Density Tons Paved",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Blue Earth",null,null,0,null,null,"SPWEA530","H= PG 70-28",null,null,"Left Shldr"]
[null,null,null,null,null,null,null,null,"Tons Per Lot",null,null,null,"MDR/Rec#",null,null,null,null,null,null,null,null,null,null,null,null,8,"Brown",null,null,0,null,null,"SPWEA540",null,null,null,"Right Shldr"]
[null,null,null,null,null,null,null,null,"Lots Used for Calcuations",null,null,null,"Bid Price/Ton",null,null,null,null,null,null,null,null,null,null,null,null,9,"Carlton",null,null,0,null,null,"SPWEB230",null,null,null,"Rt. Turn Lane"]
[null,null,null,null,null,null,null,null,"Lots Required",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Carver",null,null,null,null,null,"SPWEB240",null,null,null,"Lt. Turn Lane"]
[null,null,null,null,null,null,null,null,"Over-ride # Lots",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Cass",null,null,null,null,null,"SPWEB330",null,null,null,"Ramp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Chippewa",null,null,null,null,null,"SPWEB340",null,null,null,"Loop"]
[null,null,null,null,null,null,null,null,null,null,null,"Mix Spec",null,2360,null,null,null,null,null,null,null,null,null,null,null,13,"Chisago",null,null,null,null,null,"SPWEB430"]
[null,null,null,null,null,null,null,"Test Companion",null,null,null,"Mix Type",null,null,null,null,null,null,null,null,null,null,null,null,null,14,"Clay",null,null,null,null,null,"SPWEB440"]
[null,null,null,null,null,null,null,"Cores Shown?",null,null,null,"Asphalt Binder Grade",null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Clearwater",null,null,null,null,null,"SPWEB530"]
[null,null,null,null,null,null,null,null,null,null,null,"Total Area Paved (yd2)",null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Cook",null,null,null,null,null,"SPWEB540"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Cottonwood",null,null,null,null,null,"SPWEC230"]
[null,null,null,null,null,null,null,null,null,"Left","Left","Left","Right","Right","Right",null,null,null,null,null,null,null,null,null,null,18,"Crow Wing",null,null,null,null,null,"SPWEC240"]
[null,null,"Mat",null,"Mat","Mat ","Mat","Mat","Test","LJD","LJD","LJD","LJD","LJD","LJD",null,null,null,null,null,null,null,null,null,null,19,"Dakota",null,null,null,null,null,"SPWEC330"]
[null,null,"Core","Name","Core","Station","Offset","Offset","Companion","Joint","Core","Offset","Joint","Core","Offset",null,null,null,null,null,null,null,null,null,null,20,"Dodge",null,null,null,null,null,"SPWEC340"]
[null,"Lot","ID",null,"Station","Random #","(ft.)","Random #","Core","Type","ID","(ft.)","Type","ID","(ft.)",null,null,null,null,null,null,null,null,null,null,21,"Douglas",null,null,null,null,null,"SPWEC430"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"Faribault",null,null,null,null,null,"SPWEC440"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"Fillmore",null,null,null,null,null,"SPWEC530"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"Freeborn",null,null,null,null,null,"SPWEC540"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"Goodhue",null,null,null,null,null,"SPNWA230"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"Grant",null,null,null,null,null,"SPNWA240"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"Hennepin",null,null,null,null,null,"SPNWA330"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"Houston",null,null,null,null,null,"SPNWA340"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"Hubbard",null,null,null,null,null,"SPNWA430"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"Isanti",null,null,null,null,null,"SPNWA440"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"Itasca",null,null,null,null,null,"SPNWA530"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"Jackson",null,null,null,null,null,"SPNWA540"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"Kanabec",null,null,null,null,null,"SPNWB230"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"Kanndiyohi",null,null,null,null,null,"SPNWB240"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"Kittson",null,null,null,null,null,"SPNWB330"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"Koochiching",null,null,null,null,null,"SPNWB340"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"Lac qui Parle",null,null,null,null,null,"SPNWB430"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"Lake",null,null,null,null,null,"SPNWB440"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,"Lake of the Woods",null,null,null,null,null,"SPNWB530"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"Le Sueur",null,null,null,null,null,"SPNWB540"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,"Lincoln",null,null,null,null,null,"SPNWC230"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,"Lyon",null,null,null,null,null,"SPNWC240"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,"Mahnomen",null,null,null,null,null,"SPNWC330"]
[null,null,"Daily Production",null,null,null,"Remarks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,"Marshall",null,null,null,null,null,"SPNWC340"]
[null,null,"English Tons",null,"Lot",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,"Martin",null,null,null,null,null,"SPNWC430"]
[null,null,"0-600",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,"McLeod",null,null,null,null,null,"SPNWC440"]
[null,null,"601-1000",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,"Meeker",null,null,null,null,null,"SPNWC530"]
[null,null,"1001-1600",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,"Mille Lacs",null,null,null,null,null,"SPNWC540"]
[null,null,"1601-2600",null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,"Morrison"]
[null,null,"2601-4600",null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"Mower"]
[null,null,"> 4600*",null,6,null,"Street Inspector",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,"Murray"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"Nicollet"]
[null,null,"* Add one additional lot each additional 900 tons",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,"Nobles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,"Norman"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,"Olmsted"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,"Otter Tail"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,"Pennington"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,"Pine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,"Pipestone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"Polk"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,"Pope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,"Ramsey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,"Red Lake"]

{"sheet":"Notes","index":5,"n_rows":56,"n_cols":5,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[null,"2009-05-05",null,"Problem:  Inspectors would like to have the option to hard code in the number of lots for the day"]
[null,null,null,"Changed language in Core Stationing cell I15 from \"# of Additional Over-ride Lots\" to \"Over-ride # Lots\""]
[null,null,null,"Modified logic in Core Stationing cell k13"]
[null,null,null," from =IF(K15>0,(VLOOKUP(K11,AB5:AC10,2)+K15),(VLOOKUP(K11,AB5:AC10,2)))"]
[null,null,null,"to = if(((isnumber(k15))=true,k15,(vlookup(k11,AB5:AC10,2)))"]
[]
[null,"2009-05-13",null,"Problem:  If the same lane name is used in mutiple rows with gaps in the stationing, the spreadsheet may"]
[null,null,null,null,"choose a core stationing in exception areas that are in the lanes specified."]
[null,null,null,"Solution:","Created a row a unique letter to identify the lane names for calculation purposes.  These were inserted"]
[null,null,null,null,"in \"Core Stationing\" E83:E92.  Then the formulas were adjusted in the subsiquent cells to included the column E.  "]
[null,null,null,null,"Row 110 was added so the unique letter names are changed back to the user inputed names."]
[]
[null,null,null,"Problem:","Would like three choices for if companion cores are tested.  (All, 1 per Lot, No) "]
[null,null,null,"Solution:","Modified \"Core Stationing\" J19 to have the choices (All, 1 per Lot, No) instead of (Yes, No)"]
[null,null,null,null,"Modified equation for cells I26:I37"]
[null,null,null,null,"from =if($k$14>=1,(if(and($j$19=\"Yes\",$F123=\"Y\"),$F123,\"\"),\"\")"]
[null,null,null,null,"to =if($k$14>=1,(if($J$19=\"All\",\"Y\",if(and($J$19=\"1 per Lot\",$F123=\"Y\"),$F123,\"\"))),\"\")"]
[]
[null,"2009-05-27",null,"Problem:","The drop down boxes are limiting for inputting data for inspectors (Lift, Direction, Lane) "]
[null,null,null,"Solution:","Remove drop down boxes so description can be manually chosen."]
[null,null,null,null,"Removed drop down (B10:B19)"]
[null,null,null,null,"I have not determined a way in Excel to have a drop down box that can be manually overwritten."]
[]
[null,"2009-06-04",null,"Problem:","Cores were being randomly selected for mat cores from only the mat width -2 feet"]
[null,null,null,"Solution:","Recoded equations so the entire mat can be randomly selected."]
[null,null,null,"Changed equation in cells I168:I179"]
[]
[null,"2009-06-04",null,"Problem:","XX.2 cores were not being offset by if LJD core was in that lot."]
[null,null,null,"Solution:","Inserted missing equations."]
[null,null,null,"Copied equations into XX.2 missing cells in J168:L179"]
[]
[null,"2009-06-09",null,"Problem:","Non LJD projects were coded so that the cores were no closer than 1 foot from the edge of the mat (confiined or unconfined)"]
[null,null,null,"Solution:","Reduced type of joint column to one, and recoded sheet so that unconfined and confined edges would have different calculations."]
[null,null,null,null,"Reduced type of joint column to one (I26:I37)"]
[null,null,null,null,"Coded Non LJD core logic by inserted columns J168:L179"]
[null,null,null,null,"Recoded logic in columnP168:P179 to search for non LJD cores in column L instead of I"]
[]
[null,"2009-07-10",null,"Problem:","Needed a blank cores stationing sheet"]
[null,null,null,"Solution:","Created tab \"Core Stationing Blank\" with all cell cleared"]
[]
[null,"2010-01-29",null,"Problem:","Type of joint pick list is only available once. It is needed for both edge cores."]
[null,null,null,"Solution:","Copied pick list a second time are reformatted to put next to right and left edge cores."]
[]
[null,"2010-03-01",null,"Problem:","Field personnel would like cell N19 to display yd^2 instead of ft^2"]
[null,null,null,"Solution:","Made change to display yd^2"]
[]
[null,"2011-06-27",null,"Problem:","Number of LJD core lots was not calculating correctly"]
[null,null,null,"Solution:","Fixed formula in C155.  Instead of going off the number of lots, it will using the number of tons"]
[]
[null,null,null,"Problem:","Extra LJD cores lots were being show when they did not exist"]
[null,null,null,"Solution:","Fixed formula in cells S198:V205.  Incorrect cell references were being used"]
[]
[null,"2012-04-23",null,"Updated dates for 2012 and fixed formatting "]
[]
[null,"2012-08-13",null,"Reformatted Comments text box"]